package com.winit.datasync.utils;

/**
 * 常量信息
 * 
 * @author liangming.deng
 *
 */
public class ConstantUtils {

	public final static String EQUAL = "=";

	public final static String WHERE = " WHERE ";

	public final static String CASSANDRA_GET_ALL = "SELECT  ID, NAME, DESCRIPTION, ORG_ID, IS_ACTIVE, CREATED, CREATEDBY, UPDATED,UPDATEDBY FROM UPS_CALENDAR";

	public final static String ORACLE_GET_ALL = "SELECT * FROM UPS_TEST_CONFIG";

	public final static String ORACLE_DELETE = "DELETE FROM UPS_TEST_CONFIG";

	public final static String ORACLE_BATCH_INSERT = "INSERT INTO UPS_TEST_CONFIG(ID, NAME, DESCRIPTION, ORG_ID, CREATED, CREATEDBY) VALUES(?,?,?,?,?,?)";

	public final static String CASSANDRA_GET_UPS_CUSTOMER_MERCH_SALE = "SELECT  "
			+ " warehouse_code,warehouse_name,customer_code,customer_name,merchandise_serno,merchandise_code,qty,"
			+ "remarks,created,createdby,isactive,isdelete,updated,updatedby FROM CUSTOMER_MERCHSALE";

	public final static String ORACLE_GET_UPS_CUSTOMER_MERCH_SALE = "SELECT * FROM UPS_CUSTOMER_MERCHSALE";

	public final static String ORACLE_DELETE_UPS_CUSTOMER_MERCH_SALE = "DELETE FROM UPS_CUSTOMER_MERCHSALE";

	public final static String ORACLE_BATCH_INSERT_UPS_CUSTOMER_MERCH_SALE = "INSERT INTO UPS_CUSTOMER_MERCHSALE("
			+ "warehouse_code,warehouse_name,customer_code,customer_name,merchandise_serno,merchandise_code,qty,"
			+ "remarks,created,createdby,isactive,isdelete,updated,updatedby"
			+ ") VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

	public final static String CASSANDRA_GET_UPS_WAREHOUSE = "SELECT  "
			+ " code,sales_days,bj_date_of_cal_store,city,city_code,country,country_code,created,createdBy,"
			+ " is_active,name,org_id,region_code,region_name,state,updated,updatedby,warehouse_group,warehouse_id,newtime_zone"
			+ " FROM UPS_WAREHOUSE";
	public final static String ORACLE_GET_UPS_WAREHOUSE = "SELECT * FROM UPS_WAREHOUSE";

	public final static String ORACLE_DELETE_UPS_WAREHOUSE = "DELETE FROM UPS_WAREHOUSE";

	public final static String ORACLE_BATCH_INSERT_UPS_WAREHOUSE = "INSERT INTO UPS_WARHOUSE("
			+ " code,sales_days,bj_date_of_cal_store,city,city_code,country,country_code,created,createdBy,"
			+ " is_active,name,org_id,region_code,region_name,state,updated,updatedby,warehouse_group,warehouse_id,newtime_zone"
			+ ") VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

	public final static String MAIL_START = "存储仓ups配置日常同步监控:";
	public final static String MAIL_EXCEPTION = " 存储仓ups配置同步 程序执行报错，错误信息如下:";
}
